<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
  <style type="text/css"> 
<!-- 
a:link { 
font-size: 14px; 
color: #000000; 
text-decoration: none; 
} 
a:visited { 
font-size: 14px; 
color: #000000; 
text-decoration: none; 
} 
a:hover { 
font-size: 14px; 
color: #999999; 
text-decoration: underline; 
} 
--> 
</style>
  </head>
  
  <body>
  <script language=javascript>
function show(no)
{
for(var i=1;i<20;i++)
{
var a = document.getElementById(no+"@"+i);
if(a==null)
{
continue;
}
if(a.style.display=="")
{
a.style.display="none";
}else{
a.style.display="";
}
}

}
</script>
   <%
//定义四个分页会用到的变量
int pageSize=10;
int pageNow=1;//默认显示第一页
int rowCount=0;//该值从数据库中查询
int pageCount=0;//该值是通过pageSize和rowCount
//接受用户希望显示的页数（pageNow）
String s_pageNow=request.getParameter("pageNow");
if(s_pageNow!=null){
//接收到了pageNow
pageNow=Integer.parseInt(s_pageNow);
}
//查询得到rowCount
Class.forName("com.mysql.jdbc.Driver").newInstance(); 
String url="jdbc:mysql://localhost:3306/graduatedesign";  
String user="root";  
String password="root";  
Connection conn = DriverManager.getConnection(url, user, password); 
Statement sm=conn.createStatement();
ResultSet rs=sm.executeQuery("select count(*) from role");
if(rs.next()){
rowCount=rs.getInt(1);
}
//计算pageCount
if(rowCount%pageSize==0){
pageCount=rowCount/pageSize;
}else{
pageCount=rowCount/pageSize+1;
}
//查询出需要显示的记录
rs=sm.executeQuery("select id,ROLE from role limit " + (pageNow-1)*pageSize+","+pageSize);
%>

<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#BBD3EB">
                          <tr>
                            <td height="27" align="center" background="/OA/admin/images/index1_72.gif" bgcolor="#FFFFFF">角色名</td>
                            <td height="27" align="center" background="/OA/admin/images/index1_72.gif" bgcolor="#FFFFFF">修改</td>
                            <td height="27" align="center" background="/OA/admin/images/index1_72.gif" bgcolor="#FFFFFF">删除</td>
    </tr>
<%
while(rs.next()){
%>
<tr>
                            <td height="26" align="center" bgcolor="#FFFFFF"><%=rs.getString(2)%></td>
                            <td height="26" align="center" bgcolor="#FFFFFF"><a href="admin/roleedit.jsp?id=<%=rs.getInt(1) %>&title=<%=rs.getString(2) %>">修改</td>
                            <td height="26" align="center" bgcolor="#FFFFFF"><a href="roledid?id=<%=rs.getInt(1) %>" onclick="alert('删除成功')">删除</a></td>
                          </tr>
<%}%>
<tr>
<td height="26" colspan="10" align="center" bgcolor="#FFFFFF"><font color='#1157B7'><input type="button" value="添加" onclick="window.location.href='admin/roleadd.jsp';"/></td>
          
                            
                          </tr>
</table>
  </body>
</html>
